from sqlalchemy import Column
from sqlalchemy.sql.sqltypes import Integer, String, Text, TIMESTAMP
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()

class CourtAnnouncement(Base):
    __tablename__ = "TYC_JR_COURT_ANNOUNCEMENT"
    ID	= Column(Integer)
    ANNOUNCE_ID	= Column(Integer,primary_key=True)
    BLTNNO = Column(String(50))
    BLTNSTATE	= Column(String(20))
    BLTNTYPE	= Column(String(10))
    BLTNTYPENAME	= Column(String(100))
    CASENO	= Column(String(200))
    CONTENT	= Column(Text)
    COURTCODE	= Column(String(500))
    DEALGRADE	= Column(String(10))
    DEALGRADENAME	= Column(String(50))
    JUDGE	= Column(String(50))
    JUDGEPHONE	= Column(String(50))
    MOBILEPHONE	= Column(String(50))
    PARTY1	= Column(Text)
    PARTY2	= Column(Text)
    COMPANYLIST	= Column(Text)
    PROVINCE	= Column(String(50))
    PUBLISHDATE	= Column(String(255))
    PUBLISHPAGE	= Column(String(50))
    REASON	= Column(String(500))

    ENTNAME = Column(String(100))
    PRIPID = Column(String(36))
    REGNO = Column(String(50))
    UNISCID = Column(String(18))
    CREATE_TIME = Column(TIMESTAMP)
    UPDATE_TIME = Column(TIMESTAMP)